[dbo].[IQA_Query

[dbo].[IQA_Query_Cache]

SQLServer > iMIS1521GA > Tables > dbo.IQA_Query_Cache

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Created	10:31:25 AM Tuesday, March 02, 2010
Last Modified	11:40:03 AM Monday, February 20, 2012

Columns

	Name	Data Type	Max Length (Bytes)
$Cluster Key IX_IQA_Query_Cache: UserId\QueryId$	UserId	varchar(60)	60
$Cluster Key IX_IQA_Query_Cache: UserId\QueryId$	QueryId	varchar(50)	50
	Value	varchar(50)	50

Indexes

	Name	Columns
$Cluster Key IX_IQA_Query_Cache: UserId\QueryId$	IX_IQA_Query_Cache	UserId, QueryId

SQL Script

CREATE TABLE [dbo].[IQA_Query_Cache]
(
[UserId] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[QueryId] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Value] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
CREATE CLUSTERED INDEX [IX_IQA_Query_Cache] ON [dbo].[IQA_Query_Cache] ([UserId], [QueryId]) ON [PRIMARY]
GO

Uses